ZERO STOCK REPORT

This Reports to show the items less then 0 by Supplier


SELECT [IMAGE_NAME] ,[ITEM #] ,[ITEM NAME] ,(SELECT TITLE FROM SUPPLIER WHERE SUPPLIER_ID=[SUPPLIER]) ,[UNITS ON HAND],[STATUS],SUPPLIER FROM ITEM WHERE STATUS ='A' AND [UNITS ON HAND] <=0 ORDER BY 7
Found 95 Records
Item Item # Description Supplier Status Stock
Cinque Terre OPTICAL DRIVE_DVD_SATA_911HWUR432742 LG SATA DVD RW BLACK INTERNAL A 0
Cinque Terre TEMP_0098 PS4 GAME RESIDENT EVIL 6 A -1
Cinque Terre MONITOR_TV_ACSSMON01 17 LCD PROTECTIVE FILTER A 0
Cinque Terre SECURITY CAMERA ETC._BULLET CAMERA_CCTV CAMERA09 CW202 BULLET SHAPE INFRA RED A 0
Cinque Terre TEMP_0123 PS5 CONTROLER THIRD PARTY A 0
Cinque Terre 4.90E+12 WII LUNCHUK A 0
Cinque Terre LAPTOP_PARTS_KEYBOARD Original internal keyboard for laptop A 0
Cinque Terre SECURITY CAMERA ETC._BRACKET_CCTV BRAKET03 LONG BRACKET FOR CAMERA A -3
Cinque Terre TEMP_0030 2.4 GHZ WIRELESS GAMEPAD FOR WINDOWS MAC OS LINUX ANDROID TGZ-706W A -1
Cinque Terre TEMP_0008 BOXING WEEK SALE UP TO 50 % OFF Regular Items A 0
Cinque Terre ELECTRONICS_TABLET0007 SAMSUNG TABLET CHARGER A -1
Cinque Terre TEMP_0054 PLAYSTATION 4: NHL 19 A 0
Cinque Terre CELL PHONE AND ACCS_COVER_0430 iPHONE 15 PLUS Clear Case by SPACE COLLECTION A -3
Cinque Terre TEMP_0043 Star Wars Squadrons Game A 0
Cinque Terre TEMP_0049 PLAYSTATION 4: MINECRAFT PLAYSTATION 4 EDITION A -1
Cinque Terre TEMP_0051 PLAYSTATION 4: NHL 18 A 0
Cinque Terre MEMORY_DESKTOP_DDR4_0007 Corsair Vengeance LPX 16GB 2x8GB DDR4 DRAM 3200MHz C16 Desktop Memory Kit A -1
Cinque Terre TEMP_0061 PLAYSTATION 4: WHITE DAY A -1
Cinque Terre TEMP_0072 PLAYSTATION 4: Deus Ex Mankind Divided Day One Edition A 0
Cinque Terre TEMP_0057 PLAYSTATION 4: ASSASSINS CREED THE EZIO COLLECTION A -1
Cinque Terre SOFTWARE_ANTIVIRUS_0020 kaspersky anti virus 1 year subscription A -1
Cinque Terre HEADPHONE_MICROPHONE4 SOMIC SM001 MICROPHONE A -2
Cinque Terre TEMP_0115 PLAYSTATION 5: WHITEDAY Including Costume DLC A 0
Cinque Terre SECURITY CAMERA ETC._CAMERA_0007 EAGLESTAR PRO 23-3355 used INDOOR/OUTDOOR CAMERA POWERONE A 0
Cinque Terre CABLES_VGA_0007 VGA 40FT SHIELDED M TO M CABLE COMPUTER PLUG A 0
Cinque Terre STORAGE_SATA 3.5_0001 SATA 3.5 2TB HDD SEAGATE . QUAD SOURCE A -1
Cinque Terre STORAGE_USB DRIVE_0027 KINGSTON USB-C 3.2 TYPE C 64 GB FLASH DDRIVE DT70 64 QUAD SOURCE A 0
Cinque Terre LAPTOP_POWER SUPPLY_RP018 7.4X5.0, HP 19V 4.74A CONNECTOR POWER SUPPLY QUAD SOURCE A 0
Cinque Terre STORAGE_SATA 2.5_0018 SEAGATE 1TB 2.5 INCH SATA HARD DRIVE QUAD SOURCE A -1
Cinque Terre MEDIA_SDMMC_MEM CARD_0013 kingston microsd sdcs2 256gb class 10 QUAD SOURCE A -2
Cinque Terre LAPTOP_POWER SUPPLY_RP_0008 Type C USB-C, APPLE 87-Watt USB 3.1 AC Power Adapter QUAD SOURCE A -2
Cinque Terre CABLE_PHONE_001 RJ11 PHONE CABLE 6 FEET QUAD SOURCE A 0
Cinque Terre KEYBOARD MOUSE AND ACCS_KBW_0003 KEYBOARD: TARGUS KB214 WIRELESS KEYBOARD QUAD SOURCE A -2
Cinque Terre ELECTRONICS_TABLET0028 ASUS TABLET 5V 2A MICRO USB 5PIN CHARGER QUAD SOURCE A -1
Cinque Terre GEN-ACCESSORIES_CABLE TIE_0001 GE NAIL IN CLIPS QUAD SOURCE A 0
Cinque Terre ELECTRONICS_TABLET0022 3.0X1.0 CONNECTOR ACER TABLET 12V 1.5A CHARGER QUAD SOURCE A 0
Cinque Terre NETWORKING_RANGE EXTENDER_0003 TP-LINK RE300 AC1200 MESH WI-FI EXTENDER DUAL-BAND NEW QUAD SOURCE A 0
Cinque Terre KEYBOARD MOUSE AND ACCS_MOUSE_0014 MOUSE: HP X3000 Wireless Mouse QUAD SOURCE A 0
Cinque Terre KEYBOARD MOUSE AND ACCS_PAD_0018 PRINTED GAMING MOUSE PAD 60INC X110 INCH QUAD SOURCE A 0
Cinque Terre ELECTRONICS_REMOTE_0007 GE 24944 UNIVERSAL REMOTE QUAD SOURCE A -5
Cinque Terre HEADPHONE_PC_HPWM_0014 OVLENG GT66 Gaming Headset with Mic QUAD SOURCE A 0
Cinque Terre CELL PHONE AND ACCS._CHARGER_0123 WALL CHARGER COMBO: TYPE C 20W QC3.0 QUAD SOURCE A -3
Cinque Terre HEADPHONE_PC_HPWM_0012 HP DHE-8002 Gaming Headset Black With Mic QUAD SOURCE A 0
Cinque Terre TEMP_0060 PLAYSTATION 4: CALL OF DUTY WWII C A 0
Cinque Terre SR_SERVICE_CELLPHONE_CHIMERA PHONE UNLOCKING (CHIMERA) IN HOUSE C A -187
Cinque Terre TEMP_014 IPOD 5G 32GB USED C A -1
Cinque Terre TEMP_0108 KINGDOM HEARTS C A 0
Cinque Terre SR_SERVICE_LAPTOP Laptop Repair IN HOUSE C A -165
Cinque Terre MONITOR_TV_MONITOR015 ACER X193W 19 INCH WIDESCREEN LCD MONITOR (USED) C A 0
Cinque Terre LAPTOP_USED_REFURBISHED_0066 ACER ASPIRE V5-561P-6489 i5 C A 0
Cinque Terre CELL PHONE AND ACCS._PHONE_0611 SAMSUNG GALAXY A06 USED 10-10 CONDTION C A -1
Cinque Terre CELL PHONE AND ACCS._SCREEN 14 TEMPERED GLASS: Samsung Galaxy S3 i9300 C A -4
Cinque Terre SPEAKERS_2.0_0019 DELL SOUNDBAR BAR AUDIO SPEAKER AC511 DP-N 0MN008 FOR PC 2.5W COM SOURCE A -1
Cinque Terre DESKTOP_USED_0192 HP ProDesk 400 G1 SFF i5-4570 3.2GHz 8GB 500GB HDD Windows 10 Pro COM SOURCE A -4
Cinque Terre CELL PHONE AND ACCS._SCREEN 027 APPLE iPAD AIR SCREEN PROTECTOR (PLAIN) BUDGET ELECTRONICS (C) A -1
Cinque Terre CELL PHONE AND ACCS._PARTS_00018 Blackberry Curve (C-x2) Battery BUDGET ELECTRONICS (C) A 0
Cinque Terre CELL PHONE AND ACCS_COVER_0050 SAMSUNG GALAXY S4 OTTER CASE BUDGET ELECTRONICS (C) A -1
Cinque Terre CELL PHONE AND ACCS_COVER_0089 IPHONE 5/5S slim armor BUDGET ELECTRONICS (C) A -2
Cinque Terre CELL PHONE AND ACCS._POUCH_019 Universal Leather Case with Keyboard - 9 inch Tablets BUDGET ELECTRONICS (C) A 0
Cinque Terre CELL PHONE AND ACCS._CHARGER_0038 DOCKING CHARGER: IPHONE 6, 6 PLUS CHARGING DOCK BUDGET ELECTRONICS (C) A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0081 HTC Battery for DESIRE 601 NEXUS C A 0
Cinque Terre SR_SERVICE_USMAN REPAIR FROM USMAN USMAN (CELL PHONE) A -4
Cinque Terre CELL PHONE AND ACCS._SIM_001 Nano Sim Adaptor UR WIRELESS A -22
Cinque Terre CELL PHONE AND ACCS._SCREEN 24 APPLE IPAD 2/3/4 TEMPERED GLASS UR WIRELESS A -2
Cinque Terre CELL PHONE AND ACCS._SCREEN_0046 TEMPERED GLASS: SAMSUNG GALAXY A10 UR WIRELESS A -5
Cinque Terre TEMP_0031 POWER BANK 10000MAH PISEN 12W UR WIRELESS A -2
Cinque Terre CELL PHONE AND ACCS._CHARGER_0126 WIRELESS CHARGER: PISEN 15W UR WIRELESS A 0
Cinque Terre CELL PHONE AND ACCS._POUCH_0091 TARGUS SAFE FIT 9 TO 10 INCH TABLET CASE UR WIRELESS A 0
Cinque Terre CELL PHONE AND ACCS._SIM_005 ROGERS SIM CARD UR WIRELESS A -1
Cinque Terre CELL PHONE AND ACCS_COVER_0196 CREATIVE FASHION CASE LG K4 2017 WALLET CASE UR WIRELESS A -2
Cinque Terre CELL PHONE AND ACCS._SCREEN_0041 TEMPERED GLASS: IPHONE XS MAX 6.5 UR WIRELESS A -7
Cinque Terre CELL PHONE AND ACCS._SIM_006 FIDO SIM CARD UR WIRELESS A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0291 IPHONE 8, 8 PLUS HOME BUTTON BLACK ESOURCE PARTS A 0
Cinque Terre GEN-ACCESSORIES_WEBCAM_0017 Logitech C270 Desktop or Laptop Webcam HD 720p Widescreen for Video Calling and Recording used IN HOUSE ASSEMBLE A 0
Cinque Terre ELECTRONICS_OTHER_0002 Square Reader for magstripe with Lightning connector New Open Box IN HOUSE ASSEMBLE A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0333 MOTO G6 PLAY LCD ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_LCD_0015 SAMSUNG S21 ULTRA LCD REPLACEMENT ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_LCD_0008 SAMSUNG S10 PLUS LCD REPLACEMENT ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0165 ALCATEL ONE TOUCH IDOL X6040 LCD DIGITIZER White ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0297 SAMSUNG J727 LCD BLACK ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0325 IPHONE X CHARGING PORT FLEX ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0251 SAMSUNG GALAXY S6 BACK COVER GOLD ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0433 huawei p20 pro back cover black ETECPRO A 0
Cinque Terre CELL PHONE AND ACCS._SIM_008 ROGERS SIM CARD TRIPLE COMBO BUDGET ELECTRONICE A -1
Cinque Terre CELL PHONE AND ACCS._GEN_0003 Mobile Phone Screen Magnifier BUDGET ELECTRONICE A -1
Cinque Terre CELL PHONE AND ACCS_COVER_0121 Hybrid Case - iPhone 6/6S BUDGET ELECTRONICE A 0
Cinque Terre CELL PHONE AND ACCS._PARTS_0063 BLACKBERRY Z10 REPLACEMENT BATTERY BUDGET ELECTRONICE A 0
Cinque Terre CELL PHONE AND ACCS_COVER_0146 YESIDO IPHONE 7/8 PLUS FASHION CASE GRAY CELLNTELL C A -2
Cinque Terre CELL PHONE AND ACCS._POUCH_0044 GOOSPERY BLUE MOON LG G6 BLACK WALLET COVER CELLNTELL C A -2
Cinque Terre CELL PHONE AND ACCS._PARTS_0306 SAMSUNG GALAXY S8 BACK COVER BLACK CELLNTELL A 0
Cinque Terre CELL PHONE AND ACCS._CHARGER_0018 WALL CHARGER COMBO: SAMSUNG GALAXY 15W (MICRO USB SUPER FAST CHARGER) sunny wireless c A -6
Cinque Terre CELL PHONE AND ACCS_COVER_0298 NOTE 10 PRO RING MAGNET CASE sunny wireless c A -1
Cinque Terre ELECTRONICS_CONSUMER_0002 Hoco HP23 Diamond Electric Hair Clipper Hair Styling Key sunny wireless c A 0
Cinque Terre TEMP_0017 KEYBOARD: MARVO 2.4 WIRELESS KEYBOARD AND MOUSE LONGTECH INC A 0
Cinque Terre CELL PHONE AND ACCS._MOUNT_0075 TRIPOD MOBILE PHONE CAMERA TRIPOD Q-L3388 GADGET TECH WORLD A 0